Printing a Buyer Margin Report

Once you have entered all of the required information needed to generate a Buyer Margin Report, command options will appear allowing you to print or choose from a set of other print options.

The Buyer Margin Report will show gross margin by Item and buyer for each buyer/category manager, above the line and below the line based on the customer class assigned to the customer. Subtotals are listed for each buyer.

An uncosted above the line“Above the line” refers to a customer class assigned to the customer used to segregate customers that are part of a company’s regular business. Above the line customers are generally profitable and represent sales at the normal markup. and below the line"Below the line” is a customer class assigned to the customer used to segregate customers that are not part of normal business. This customer class is also referred to as low margin customers or those sold at a less than normal markup. summary page for each buyers by customer class will also be included as part of the report.

Separate summary pages will be generated by buyer for both above and below the line customer classes.  

A grand total section/page listing the grand total above the line and the grand total below the line will also be generated.  

The following information will print on the report by item first digit based on above and below the line customer classes:

• Item – The item name
• Amount Invoiced (Product) – The dollar amount invoiced for the product.
• Amount Invoiced (Other) – The dollar amount invoiced for non-product items, such as pricing exceptions set for customers (price allocations, cost buckets, cost adjustments, cost allocations, etc).
• Amount Invoiced (Total) – The total dollar amount invoiced; Product (the amount of product invoiced) + Other (non-product items invoiced).
• Actual Cost (If report was run using actual cost) – The total cost attributed to the item when Cost of Goods Sold was run.
• Standard Cost (If report was run using standard cost) – The standard cost of the product, in dollars.
• Pounds – The item amount, in pounds.
• Gross Profit – The total dollar amount of profit based on the gross profit calculation method set in Ledger Options.
• Gross Margin – The gross profit expressed as a percentage of the total amount invoiced based on the gross margin calculation method set in Ledger Options.
• Grand Total – The grand total for each of the columns (headers) listed on the report.

Note: Each item first digit and buyer will have subtotals correlating with each of the report columns (headers) previously listed (see above).

Note: Grand Total Above, Grand Total Below, and Grand Total are calculated for each column of the Route Margin Report: product invoiced (in dollars), other-type product invoiced (in dollars), total amount invoiced (in dollars), actual cost of items invoiced (in dollars), pounds of items invoiced, gross profit (in dollars), and gross margin (as a percentage).

For more information on the Buyer Margin Report option see Buyer Margin Report.

Security Required : System - Profit Margin